
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[spShippingLineGetByCode]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [spShippingLineGetByCode]
GO

CREATE PROCEDURE spShippingLineGetByCode
	@Code varchar(20)
AS

SELECT
	[ID],
	[Abbr],
	[Name],
	[URL]
FROM
	[ShippingLine]
WHERE
	[Abbr] = @Code

GO
	

	
